by michael.adeyemi

FinTrack

Data Analysis

FinTrack is a financial analytics dashboard that helps small businesses monitor revenue, expenses, and monthly cash flow from a single interface.

GitHub Live Link View Talent

Project Details

Overview

FinTrack is an all-in-one financial dashboard for small businesses that consolidates revenue, expenses, and cash flow analysis. By replacing scattered spreadsheets with a single interface, it delivers clear insights to help owners drive profitability and growth.

Problem

Small businesses often rely on fragmented spreadsheets, causing errors, data inconsistencies, and delayed insights. An integrated financial management solution streamlines reporting, improves accuracy, and enhances overall efficiency.

Goal

Create an intuitive, interactive dashboard that delivers real-time business insights by integrating data from multiple sources. It should feature customizable visualizations and automated alerts to help stakeholders track key metrics and make proactive decisions with minimal manual effort.

Solution

The application integrates transactional data with Power BI dashboards for comprehensive analysis, while SQL ensures accurate and efficient data processing. This collaboration delivers timely, insightful reports that enhance decision-making.

Outcome

Dashboard refresh reduced reporting time by 85%.
Interactive charts improved visibility into monthly spending patterns.
Generated automated executive reports.
Implemented data validation procedures, enhancing the accuracy of financial summaries.
Streamlined collaboration between departments by integrating reporting tools with centralized data sources.
Provided actionable insights that supported strategic decision-making for senior management.

Program

Data Science & Machine Learning

Cohort

January 2026

Submission Date

April 24, 2026

Project Type

Capstone Project

Tools / Softwares

Excel

PostgreSQL

Power BI